SUPPORT / SAMPLES & SAS NOTES
Problem Note 60473: Incorrect numbers for side-by-side joins occur when the number of market states is different between the two subcubes in the join
 |  |  |  |  |
When you use SAS® High-Performance Risk to perform side-by-side joins and the number of market states is different between the two subcubes, the joined cube results do not match. This issue occurs when joins use the following types of subcubes:
- Created from PRICEBY=POSITIONS
- Created from PRICEBY=STATES
- Resulting from the use of the GET_STATISTIC function or from the use of the GET_RANKED_VALUES or GET_RANKED_VALUES_TOP CALL routine in a user-defined statistic
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS High-Performance Risk | Microsoft® Windows® for x64 | 3.7 | 3.8 | 9.4 TS1M4 | 9.4 TS1M4 |
| 64-bit Enabled AIX | 3.7 | 3.8 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| 64-bit Enabled Solaris | 3.7 | 3.8 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Linux for x64 | 3.7 | 3.8 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Solaris for x64 | 3.7 | 3.8 | 9.4 TS1M4 | 9.4 TS1M4 | ||